-
Re: INDEX and MATCH across two sheets: a detailed explanation
missing something....can you take a look at =IF(OR(INDEX({sheet A range}, MATCH([Sheet B]@row, {sheet A range},0))= [Sheet B]@row, INDEX({sheet C range}, MATCH([Sheet B]@row, ({sheet C range},0)),1)…1 ·